package com.data.app.dao.primary;

import com.data.app.pojo.primary.QhSiteClassResultEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface QhSiteClassResultBaseDao extends JpaRepository<QhSiteClassResultEntity, String> {

    // @Query(value = "select usa_classi,coordinates from qh_site_class_result", nativeQuery = true)
    @Query(value = "select usa_classi,coordinates,province from qh_site_class_result_city2", nativeQuery = true)
    List<Object[]> findSitClassAndCoordinatesAll();
}
